﻿using System;

namespace edowork.com.Model
{
    #region purchaseInfo

    [Serializable]
    public class purchaseInfo
    {
        #region Private fields

        protected string _pcsid = String.Empty;
        protected string _pspid = String.Empty;
        protected string _billtype = String.Empty;
        protected string _billdate = String.Empty;
        protected string _arrivaldate = String.Empty;
        protected string _supplierid = String.Empty;
        protected string _phone = String.Empty;
        protected string _fax = String.Empty;
        protected string _settleid = String.Empty;
        protected string _period = String.Empty;
        protected string _userid = String.Empty;
        protected string _sysdate = String.Empty;
        protected string _remark = String.Empty;
        protected string _staffID = String.Empty;
        protected string _invoicestu = String.Empty;
        protected string _staffstu = String.Empty;
        protected string _staffremark = String.Empty;
        protected string _checkuserid = String.Empty;
        protected string _checkdate = String.Empty;
        protected string _checkstu = String.Empty;
        protected string _checkremark = String.Empty;
        protected string _m_stu = String.Empty;
        protected string _m_date = String.Empty;
        protected string _m_ID = String.Empty;
        protected string _b_open = String.Empty;

        #endregion

        public purchaseInfo() { }

        #region Public Properties

        public string Pcsid
        {
            get { return _pcsid; }
            set { _pcsid = value; }
        }

        public string Pspid
        {
            get { return _pspid; }
            set { _pspid = value; }
        }

        public string Billtype
        {
            get { return _billtype; }
            set { _billtype = value; }
        }

        public string Billdate
        {
            get { return _billdate; }
            set { _billdate = value; }
        }

        public string Arrivaldate
        {
            get { return _arrivaldate; }
            set { _arrivaldate = value; }
        }

        public string Supplierid
        {
            get { return _supplierid; }
            set { _supplierid = value; }
        }

        public string Phone
        {
            get { return _phone; }
            set { _phone = value; }
        }

        public string Fax
        {
            get { return _fax; }
            set { _fax = value; }
        }

        public string Settleid
        {
            get { return _settleid; }
            set { _settleid = value; }
        }

        public string Period
        {
            get { return _period; }
            set { _period = value; }
        }

        public string Userid
        {
            get { return _userid; }
            set { _userid = value; }
        }

        public string Sysdate
        {
            get { return _sysdate; }
            set { _sysdate = value; }
        }

        public string Remark
        {
            get { return _remark; }
            set { _remark = value; }
        }

        public string StaffID
        {
            get { return _staffID; }
            set { _staffID = value; }
        }

        public string Invoicestu
        {
            get { return _invoicestu; }
            set { _invoicestu = value; }
        }

        public string Staffstu
        {
            get { return _staffstu; }
            set { _staffstu = value; }
        }

        public string Staffremark
        {
            get { return _staffremark; }
            set { _staffremark = value; }
        }

        public string Checkuserid
        {
            get { return _checkuserid; }
            set { _checkuserid = value; }
        }

        public string Checkdate
        {
            get { return _checkdate; }
            set { _checkdate = value; }
        }

        public string Checkstu
        {
            get { return _checkstu; }
            set { _checkstu = value; }
        }

        public string Checkremark
        {
            get { return _checkremark; }
            set { _checkremark = value; }
        }

        public string M_stu
        {
            get { return _m_stu; }
            set { _m_stu = value; }
        }

        public string M_date
        {
            get { return _m_date; }
            set { _m_date = value; }
        }

        public string M_ID
        {
            get { return _m_ID; }
            set { _m_ID = value; }
        }

        public string B_open
        {
            get { return _b_open; }
            set { _b_open = value; }
        }

        #endregion

        #region Public SQL Script

        public string SQL_Insert()
        {
            return "insert into purchase(Pcsid,Pspid,Billtype,Billdate,Arrivaldate,Supplierid,Phone,Fax,Settleid,Period,Userid,Sysdate,Remark,StaffID,Invoicestu,Staffstu,Staffremark,Checkuserid,Checkdate,Checkstu,Checkremark,M_stu,M_date,M_ID,B_open) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}','{21}','{22}','{23}','{24}')";
        }

        #endregion

    }

    #endregion
}

